package test;

import java.sql.Connection;
//import java.sql.ResultSet;
import db.DBConnection;



public class test {
	
	public static void main(String[] args){		
		
		try {
//		    String sq="select * from idf_0000";
//		    String table = " create table ";
//		    String table2 = 		" ( id int unsigned auto_increment primary key,word varchar(20), tf int unsigned, score float);";
		  
		    
		    String tabledelete = "delete from ";
		    
		    
		    DBConnection dbcon = new DBConnection();

			Connection conn = dbcon.getConnection();
			java.sql.Statement st = conn.createStatement();		

			
			for(int i= 0;i<1000;i++){
				
				String name = "idf_" + String.valueOf(i);
				

				st.execute(tabledelete + name);
			}

				System.out.println("ok");

			st.close();
			}
			catch (Exception e) { 
			    e.printStackTrace(); 
			}
	}

}
